const Sequelize = require('sequelize')
const db = require('../db')
//定义地址实体对象模型
const Provider = db.define(
  'Provider',
  {
    id: { type: Sequelize.BIGINT, primaryKey: true, autoIncrement: true },
    proCode: { type: Sequelize.STRING },
    proName: { type: Sequelize.STRING, unique: true },
    proDesc: { type: Sequelize.STRING },
    proContact: { type: Sequelize.STRING },
    proPhone: { type: Sequelize.STRING },
    proAddress: { type: Sequelize.STRING },
    proFax: { type: Sequelize.STRING },
    createdBy: { type: Sequelize.BIGINT },
    createdAt: { type: Sequelize.DATE },
    modifyBy: { type: Sequelize.BIGINT },
    updatedAt: { type: Sequelize.DATE },
  },
  {
    underscored: false,
    tableName: 'smbms_provider',
  }
)
module.exports = Provider
